UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vwSA6oTjLkt7CnlzL6bHobEYhl9O6l6nnAAflXjlV7A=' 
WHERE 
  key_id = '9d8db8e6f58a311ee737eb71b4dce3b6febfd6e8c806c67c3ee1d06b57d82e18' 
  AND (
    token = 'vwSA6oTjLkt7CnlzL6bHobEYhl9O6l6nnAAflXjlV7A=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042