UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fp+Mt4bIt881JufDZT5OSPPOXVHX9qFPUbhE1A0FrO4=' 
WHERE 
  key_id = 'c9632d36ef7860011523c4292a0d929184c6e68a4ac809ea9d8d9f8e8e19d58a' 
  AND (
    token = 'fp+Mt4bIt881JufDZT5OSPPOXVHX9qFPUbhE1A0FrO4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021