UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HX3O2tGmeXQrcu2ln54Q+FfvGY5WsWdo8yR10vqyifA=' 
WHERE 
  key_id = 'f713433bb7884ba1c7c1067bfdc2cc7d713035f6c0ad3bff7d785d124c0e4fd2' 
  AND (
    token = 'HX3O2tGmeXQrcu2ln54Q+FfvGY5WsWdo8yR10vqyifA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00051