UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DvAi2BFnMuq0BnjHN0FnIBnxlvdvK8s8hYvRQJz70Ao='
WHERE
key_id = '368f2cb301fb33518940be1b68a5e615ebb1b0874f90b2607922b42ee983d6b4'
AND (
token = 'DvAi2BFnMuq0BnjHN0FnIBnxlvdvK8s8hYvRQJz70Ao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)