UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bdlhYXNPqfmMoF6Fg3HglwR6xnxQSPlxC19qRpPy0bU='
WHERE
key_id = 'eb927547aa30682645428245533291fd70a198b2296181677e6245afee3d9808'
AND (
token = 'bdlhYXNPqfmMoF6Fg3HglwR6xnxQSPlxC19qRpPy0bU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)