UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NQ1+W3lIcxoa+0LksPemozcTl8gevw9YGkqA+7/0Lc8=' 
WHERE 
  key_id = '837e16161a64d56c0d2e78269e2707495a6b78eeb40aff122e810b66d70f1b47' 
  AND (
    token = 'NQ1+W3lIcxoa+0LksPemozcTl8gevw9YGkqA+7/0Lc8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029