UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N4XZgj36QV1MzsH1bu7CUHkFDXIRcrUmOMNEQNsHJd0='
WHERE
key_id = '00578915ba8ffe60e78de5f02b4d57ab43778e46de396700057ae1fbe709afd7'
AND (
token = 'N4XZgj36QV1MzsH1bu7CUHkFDXIRcrUmOMNEQNsHJd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)