UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lXOvkboAPjQsJ7MKBTl0zk5vsnbG/gwRKIpNedoag1I='
WHERE
key_id = 'fd4269143327ab4091b50548d89107f9d369161a527ce5211575aed2b2ed8411'
AND (
token = 'lXOvkboAPjQsJ7MKBTl0zk5vsnbG/gwRKIpNedoag1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)