UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mzLq1+63/6XlO224r5QP2u2Onrvjlc4i44EpGUMdMq0='
WHERE
key_id = 'c9a11510766b847e7971148c46a35953ff9b84b97ab960b15421eb4950bdc2fa'
AND (
token = 'mzLq1+63/6XlO224r5QP2u2Onrvjlc4i44EpGUMdMq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)