UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V8pZcdWCmfZ5w5AnuCmZhJiboMwdY8vcsLofScS9J24='
WHERE
key_id = '14a38de4db156deb00779107bfe45870b61fe6fff3351e0a6dee1582da42955a'
AND (
token = 'V8pZcdWCmfZ5w5AnuCmZhJiboMwdY8vcsLofScS9J24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)