UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NhqPg0uvGEhjpETwwJ6WcFEAVJyWgDN596y46sdZ+J0='
WHERE
key_id = 'd815a8f2039c3629e9ebf30c8e2a74585bc8209004db63a16d245ed141583918'
AND (
token = 'NhqPg0uvGEhjpETwwJ6WcFEAVJyWgDN596y46sdZ+J0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)