UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aoolSpBiejqZ8iCu1p+HSpc3pOppBQ9eja9jHKBVgjM='
WHERE
key_id = 'd3d506bb3be694cace41f34dca0c173a7999b5ccadd965ebfb1cd412bcaf453a'
AND (
token = 'aoolSpBiejqZ8iCu1p+HSpc3pOppBQ9eja9jHKBVgjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)