UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '45mOJOKhjyknN4fDkBfxY6S7+lk8xx+2a2NjeCn4weQ=' 
WHERE 
  key_id = 'c9b7ea97549f6fe5006f652cbd45799734e85c0f737f0cfef0e5a1c2701ec539' 
  AND (
    token = '45mOJOKhjyknN4fDkBfxY6S7+lk8xx+2a2NjeCn4weQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027