UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCNqmBksBOx+22IhX8oAz34GKvxJlui9bNIl7CXKZwc='
WHERE
key_id = 'd0caea90a0b21892f8ef7d5d4c2b940492ae663ff16bb6d5c319e812aa862696'
AND (
token = 'bCNqmBksBOx+22IhX8oAz34GKvxJlui9bNIl7CXKZwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)