UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ut39rU6nD1xYPHoB6mMsuI/tfGHq6CpB8jV9Kwn9Yms=' 
WHERE 
  key_id = 'de1541c931d86a23f68e477a3e171704bd9bf599da2b2864394fec10766aab71' 
  AND (
    token = 'Ut39rU6nD1xYPHoB6mMsuI/tfGHq6CpB8jV9Kwn9Yms=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00014