UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGLJ8X5ns9jhoh4PyBeZdogZUsNergbat53EYQmSwlM='
WHERE
key_id = 'dc6078b09572bc674e98d7c6f28cf2b028c58fe7ba3955ab4face82cfef5b78d'
AND (
token = 'XGLJ8X5ns9jhoh4PyBeZdogZUsNergbat53EYQmSwlM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)