UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vgjr8DgHf/ulwKy2k6x1bmymOd1mzz+4QYfiBCG7w+8='
WHERE
key_id = '1cef809fea81717211e075afa29e208317b2f6cf6b88a082f708091a7fff4606'
AND (
token = 'vgjr8DgHf/ulwKy2k6x1bmymOd1mzz+4QYfiBCG7w+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)