UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgY1kJYH/68qM4oGvKFValn5+7PR3YOc+R3BhcxPKDU='
WHERE
key_id = 'eb4b7a7cff900e433ab17c2b1098d484faa1f5b7afca6465a761974fc15d59e5'
AND (
token = 'sgY1kJYH/68qM4oGvKFValn5+7PR3YOc+R3BhcxPKDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)