UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N+v1xkdYNJc675MyT+Hg9/CLDUxtudWQ3v0OJGPxsbo='
WHERE
key_id = '90e2edb818529f528c20497b7ce747b5185b9a7bdcb5c751a65ff9f011e5b3a7'
AND (
token = 'N+v1xkdYNJc675MyT+Hg9/CLDUxtudWQ3v0OJGPxsbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)