UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9sdJH6fwlvHvAxTxw/o1FbEsbmZL5OSHswYlk/aSbjc='
WHERE
key_id = 'e421f670fde78783d9290e0f3a03be814d03d69d934c017e7b219c2ea035e07b'
AND (
token = '9sdJH6fwlvHvAxTxw/o1FbEsbmZL5OSHswYlk/aSbjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)