UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h6ZK9bJBlgNTrxocTCWHHwdkzP4RTobGquQO0Y8Fh/k='
WHERE
key_id = '1ad2eafd0e54affbc5bc7061a1c8fd1bfb49d10a6eeae2322f12c52c9b47cf6e'
AND (
token = 'h6ZK9bJBlgNTrxocTCWHHwdkzP4RTobGquQO0Y8Fh/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)