UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '96xQWCIv01EMFAylbDfyTX9eQElmcM2aiognCaqGhI0='
WHERE
key_id = 'c5a5bcd031d5ce4b45385a13ecd5c87388a5e6472fa3f4bda95457c9872d6073'
AND (
token = '96xQWCIv01EMFAylbDfyTX9eQElmcM2aiognCaqGhI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)