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