UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'T6vZ7ZCuo09OzS3poebX5O6MAa1C0I9TQRXCTbmYjd4=' 
WHERE 
  key_id = 'c28ad47f8610677d597325ab88ac0bec32a0f189a4d3f1d5e07f09d2d97e3ffc' 
  AND (
    token = 'T6vZ7ZCuo09OzS3poebX5O6MAa1C0I9TQRXCTbmYjd4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040