UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BCe7L4INB91KdskKyr2BYLgDgsVV5FlWbL6R69rqCwc='
WHERE
key_id = '8954ae1f30029d483e369c3b287bae8de41b79ad2c106384e427c87dfed36753'
AND (
token = 'BCe7L4INB91KdskKyr2BYLgDgsVV5FlWbL6R69rqCwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)