UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KcHIyzGQNu4dIuufd/bmHUDit1eWmM36AJPWiPDML4w='
WHERE
key_id = '3e24f50fd00d0cfd72dc08c216d0be53c3f99b7f7b65110a2054de7a09bf16c5'
AND (
token = 'KcHIyzGQNu4dIuufd/bmHUDit1eWmM36AJPWiPDML4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)