UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vbnI8RYXB3SG7LDUD0Uppzb0w2u3z3Yy7x3Ka/MKjT4=' 
WHERE 
  key_id = '3db1ce7977e0fd829f6b1f773c60350b72fbcd6fc97cbc4e8741b4454db18c06' 
  AND (
    token = 'vbnI8RYXB3SG7LDUD0Uppzb0w2u3z3Yy7x3Ka/MKjT4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040