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