UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9L3ed6Ot3I02a/C0AtKbCiMC6+CBZ/zEsTLHpibinlw='
WHERE
key_id = 'e8463a47818c07a60e70d0d5179f0cc7ef7339a19b2923174426db307d9e3cb5'
AND (
token = '9L3ed6Ot3I02a/C0AtKbCiMC6+CBZ/zEsTLHpibinlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)