UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXVIrtnXou0pRi4sDI7EvCVTnIhn1KAKPVr77pJk33U='
WHERE
key_id = '84ff800c547ef6f6bae65eeed677feab431684c1ac2116e6944ed418ece4a7f5'
AND (
token = 'pXVIrtnXou0pRi4sDI7EvCVTnIhn1KAKPVr77pJk33U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)