UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZB0lzzFA+14haz4MU6+X+yXw4VAO78oOhDISmGpAlJE='
WHERE
key_id = '18470d1aac6d99859a1fd35f99c0d2b0647602e8a4b802657d7586ef93980656'
AND (
token = 'ZB0lzzFA+14haz4MU6+X+yXw4VAO78oOhDISmGpAlJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)