UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G6VxcMzfmJtsoD1VBehiD3u8tQ4+BPvmY8f42Vecaqg='
WHERE
key_id = '56cccfd98f7f8861dbd86b791a7458633a16428bd7614cf0918c2e2156f96266'
AND (
token = 'G6VxcMzfmJtsoD1VBehiD3u8tQ4+BPvmY8f42Vecaqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)