UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xjbt7vv6mtOGnAL9/GoYeMsiQ9FGdZsCZ+GleqUNnSo=' 
WHERE 
  key_id = 'a2089f4b3982e76d01c0e9ce8cbe9d6a999c2475cc852f8043fe24f63d177b88' 
  AND (
    token = 'xjbt7vv6mtOGnAL9/GoYeMsiQ9FGdZsCZ+GleqUNnSo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040